<!DOCTYPE HTML>
<html>
<head>
<link rel="stylesheet" href="http://medoo.in/css/core.css"/>
<link rel="shortcut icon" href="http://medoo.in/favicon.png" />
<meta property="og:title" content="Medoo - The lightest PHP database framework to accelerate development"/>
<meta property="og:type" content="website"/>
<meta property="og:url" content="http://medoo.in"/>
<meta property="og:image" content="http://medoo.in/images/medoo-logo-128.png"/>
<meta property="og:site_name" content="Medoo"/>
<meta property="fb:admins" content="100001162628592" />
<script>(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObjects']=r;i[r]=i[r]||function(){(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,document,'script','//www.google-analytics.com/analytics.js','ga');ga('create', 'UA-15301273-5', 'medoo.in');ga('send', 'pageview');</script><title>Medoo Documentation</title>
<meta name="keywords" content="Medoo,Medoo Guidebook" />
<meta name="description" content="Medoo documentation" />
<link href="css/tomorrow.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="js/highlight.pack.js"></script>
<script type="text/javascript">hljs.initHighlightingOnLoad();</script>
</head>
<body>
<header>
<div id="header_body" class="clearfix">
<a href="http://medoo.in"><img width="297" height="58" id="head_logo" src="http://medoo.in/images/medoo-logo.png" /></a>
<nav>
	<ul class="clearfix">
		<li><a href="http://medoo.in">Home</a></li>
		<li><a href="http://medoo.in/api/new">Get Started</a></li>
		<li><a href="http://medoo.in/doc">Documentation</a></li>
		<li><a href="http://medoo.in/about">About</a></li>
	</ul>
</nav>
</div>
</header><div id="doc_container" class="clearfix">
<div id="api_list_wrap">
<h4>Get Started</h4 >
<ul class="api_list">
<li id="api_list_new"><a href="http://medoo.in/api/new">new medoo()</a></li>
</ul>

<h4>Where Syntax</h4 >
<ul class="api_list">
<li id="api_list_where"><a href="http://medoo.in/api/where">where</a></li>
</ul>

<h4>Query</h4>
<ul class="api_list">
<li id="api_list_select"><a href="http://medoo.in/api/select">select</a></li>
<li id="api_list_insert"><a href="http://medoo.in/api/insert">insert</a></li>
<li id="api_list_update"><a href="http://medoo.in/api/update">update</a></li>
<li id="api_list_delete"><a href="http://medoo.in/api/delete">delete</a></li>
<li id="api_list_replace"><a href="http://medoo.in/api/replace">replace</a></li>
<li id="api_list_get"><a href="http://medoo.in/api/get">get</a></li>
<li id="api_list_has"><a href="http://medoo.in/api/has">has</a></li>
<li id="api_list_count"><a href="http://medoo.in/api/count">count</a></li>
<li id="api_list_max"><a href="http://medoo.in/api/max">max</a></li>
<li id="api_list_min"><a href="http://medoo.in/api/min">min</a></li>
<li id="api_list_avg"><a href="http://medoo.in/api/avg">avg</a></li>
<li id="api_list_sum"><a href="http://medoo.in/api/sum">sum</a></li>
</ul>

<h4>Transaction</h4 >
<ul class="api_list">
<li id="api_list_action"><a href="http://medoo.in/api/action">action</a></li>
</ul>

<h4>Advanced</h4>
<ul class="api_list">
<li id="api_list_query"><a href="http://medoo.in/api/query">query</a></li>
<li id="api_list_quote"><a href="http://medoo.in/api/quote">quote</a></li>
</ul>

<h4>PDO object</h4>
<ul class="api_list">
<li id="api_list_pdo"><a href="http://medoo.in/api/pdo">pdo</a></li>
</ul>

<h4>Debug</h4>
<ul class="api_list">
<li id="api_list_debug"><a href="http://medoo.in/api/debug">debug</a></li>
<li id="api_list_error"><a href="http://medoo.in/api/error">error</a></li>
<li id="api_list_log"><a href="http://medoo.in/api/log">log</a></li>
<li id="api_list_last_query"><a href="http://medoo.in/api/last_query">last_query</a></li>
</ul>

<h4>Information</h4>
<ul class="api_list">
<li id="api_list_info"><a href="http://medoo.in/api/info">info</a></li>
</ul>
</div><div id="main_body">
	<div id="doc_version">version: 1.1.3</div>
	<h3>Documentation</h3>
	<p class="desc">To get started, we recommended you to read the guide document at first, so that you can understand how to installed and start a simple code.</p>

	<ul class="api_full_list">
		<li><a href="/api/new"><h5>new medoo</h5><p>The guide of how to start using Medoo and start a database connection</p></a></li>
	</ul>

	<p class="desc">Here the article about the Medoo data filter as the argument of most Medoo function - $where, it is important to use it for filtering data to get the target data we wanted.</p>

	<ul class="api_full_list">
		<li><a href="/api/where"><h5>where</h5><p>The document about $where argument.</p></a></li>
	</ul>

	<p class="desc">Here the Medoo API list. You can find anything you want.</p>

	<ul class="api_full_list">
		<li><a href="/api/select"><h5>select</h5><p>Select data from database</p></a></li><li><a href="/api/insert"><h5>insert</h5><p>Insert new records in table</p></a></li><li><a href="/api/update"><h5>update</h5><p>Modify data in table</p></a></li><li><a href="/api/delete"><h5>delete</h5><p>Delete data from table</p></a></li><li><a href="/api/replace"><h5>replace</h5><p>Replace old data into new one</p></a></li><li><a href="/api/get"><h5>get</h5><p>Get only one record from table</p></a></li><li><a href="/api/has"><h5>has</h5><p>Determine whether the target data existed</p></a></li><li><a href="/api/count"><h5>count</h5><p>Counts the number of rows</p></a></li><li><a href="/api/max"><h5>max</h5><p>Get the maximum value for the column</p></a></li><li><a href="/api/min"><h5>min</h5><p>Get the minimum value for the column</p></a></li><li><a href="/api/avg"><h5>avg</h5><p>Get the average value for the column</p></a></li><li><a href="/api/sum"><h5>sum</h5><p>Get the total value for the column</p></a></li><li><a href="/api/query"><h5>query</h5><p>Insert new records in a table</p></a></li><li><a href="/api/quote"><h5>quote</h5><p>Quotes the string for query</p></a></li><li><a href="/api/action"><h5>action</h5><p>Start a transaction</p></a></li><li><a href="/api/debug"><h5>debug</h5><p>Output the generated SQL without execute it.</p></a></li><li><a href="/api/error"><h5>error</h5><p>Return error information associated with the last operation.</p></a></li><li><a href="/api/log"><h5>log</h5><p>Return the all executed queries.</p></a></li><li><a href="/api/last_query"><h5>last_query</h5><p>Return the last query performed.</p></a></li><li><a href="/api/info"><h5>info</h5><p>Get the information of database.</p></a></li>	</ul>
</div>
</div>

<footer>
<div id="footer_body" class="clearfix">
<a id="github_link" href="https://github.com/catfan/Medoo">
<div id="github_text">Fork me on GitHub</div>
</a><p id="footer_text">The Medoo project, All Rights Reserved, 2017.</p>
</div>
</footer></body>
</html>